I use SQL Server 6.5
I have create a trigger on UPDATE for history.
This history send the old value and the new value in a table to follow all the modifications. Those values are "text datatype".
When I execute the trigger (When I make a modification in the table), the two values are the same (the new value).
If somone have a idea ...

CREATE TABLE dbo.HELPDB (
ALMID int NOT NULL ,
MEMO text NULL ,
FIRSTAID text NULL
)
GO

CREATE TRIGGER trg_UpdateHelpDB ON dbo.HELPDB
FOR UPDATE
AS
DECLARE @Id integer
DECLARE @alm integer
DECLARE @user varchar(20)
DECLARE @almname varchar(24)
DECLARE @usergroupproprid integer
DECLARE @usergroupproprname varchar(30)
DECLARE @oldFirstAid varchar(255)
DECLARE @newFirstAid varchar(255)

if(UPDATE(FIRSTAID))
begin
select @alm = ALMID, @oldFirstAid = CONVERT(varchar(255), FIRSTAID) from deleted
select @newFirstAid = CONVERT(varchar(255), FIRSTAID) from inserted
Exec AMX.dbo.SpGetNewId 'HISTALM', @Id OUTPUT
select @user = "testuser"
select @almname = "testalmname"
select @usergroupproprname = "testusergroupproprname"
INSERT HISTALM (ID, ALMID, DATETIME, USERLOG, STATUS, ALMNAME, USERGRPPROPR,USERGRPOWNER, EVENTTYPE, OLDVALUE, NEWVALUE)
VALUES(@Id, @alm, getdate(), @user, "First Aid", @almname, @usergroupproprname, "/", 0, @oldFirstAid, @newFirstAid)
END
GO

CREATE TABLE dbo.HISTALM (
ID int NOT NULL ,
ALMID int NOT NULL ,
DATETIME datetime NOT NULL ,
USERLOG varchar (30) NOT NULL ,
STATUS varchar (25) NOT NULL ,
ALMNAME varchar (24) NOT NULL ,
USERGRPPROPR varchar (30) NOT NULL ,
USERGRPOWNER varchar (30) NOT NULL ,
EVENTTYPE int NOT NULL ,
OLDVALUE varchar (255) NULL ,
NEWVALUE varchar (255) NULL
)
GO